Excel PowerPivots Version:  PowerPivots for Excel 2010

Problem:  I have a table in PowerPivot windows using a SQL Query for a data source.  The query in question requires about 3 minutes to regenerate.  When I open Edit Table Properties for this data source the query times out and I get an error (see below):  "

Failed to retrieve data from udvTrainJobReportsData. Reason: Query timeout expired"

This seems to happen anytime I use a query that takes longer than a couple of minutes to regenerate.  Anyone have an idea on how to get around this.  Is there a timeout setting somewhere in PowerPivots that can be increased?

Regards,

....bob

Screen Shot of Error:

Hi,

Please try to use Query sentence to import the table. Such as " Selcet * from cost".

Then we could change the General Timeout value. Click From database> From SQL>Advanced

Thanks,

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"

Hi George,

Thanks for looking at this.  When inputting timeout values; are the units seconds or minutes?  Also is the SQL Query a requirement to being able to set the timeout values?

Thanks,

...bob

Hi,

We could add the seconds in the timeout values.

Then, if you want to add the timeout values for the SQL Query, please following the link to do:

http://aniruddhathengadi.blogspot.in/2012/07/ole-db-error-ole-db-or-odbc-error-query.html

Please Note: Since the web site is not hosted by Microsoft, the link may change without notice. Microsoft does not guarantee the accuracy of this information.

And here is a similar issue.

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/59dbdd8e-9981-41c5-a02c-9365c46956e1/how-to-extend-the-timeout-for-long-running-queries?forum=sqlkjpowerpivotforexcel

Thanks,

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"

• Edited by George.Zhao CHNMicrosoft contingent staff, Moderator 10 hours 34 minutes ago
• Marked as answer by ConstPM 7 hours 36 minutes ago

Hi,

We could add the seconds in the timeout values.

Then, if you want to add the timeout values for the SQL Query, please following the link to do:

http://aniruddhathengadi.blogspot.in/2012/07/ole-db-error-ole-db-or-odbc-error-query.html

Please Note: Since the web site is not hosted by Microsoft, the link may change without notice. Microsoft does not guarantee the accuracy of this information.

And here is a similar issue.

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/59dbdd8e-9981-41c5-a02c-9365c46956e1/how-to-extend-the-timeout-for-long-running-queries?forum=sqlkjpowerpivotforexcel

Thanks,

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"

• Edited by George.Zhao CHNMicrosoft contingent staff, Moderator Friday, December 27, 2013 1:18 AM
• Marked as answer by ConstPM Friday, December 27, 2013 4:16 AM